Additional Functions
Expressions can use all of the intrinsic functions available to
NSQL. In addition, there are several other functions available:
- IURN(<column>) - returns a unique 0 based
record number generated by the system
- MAXIMUM(<column>,<column>) - returns
whichever is the greater value of the two columns for each row in the table
- MINIMUM(<column>,<column>) - returns
whichever is the lower value of the two columns for each row in the table
- MID(<column>,<number>,<number>)
- returns a sub-string from each record of the column. This string is formed
from the 1-based offset of the first number with length given by the second
number.
|
|
